package org.spring.boot.multiple.jdbctemplate.dao;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

/**
 * @author: eastcom
 * @desc:
 **/
@Repository
public class IrmsCityDaoImpl implements IrmsCityDao {

	@Autowired
	private JdbcTemplate irmsJdbcTemplate;

	@Override
	public List<Map<String, Object>> queryForList(String cityId) {
		String sql = "SELECT * FROM IRMS.IRMS_SPACE_CITY WHERE ID = "+cityId;
		return this.irmsJdbcTemplate.queryForList(sql);
	}
}
